Combine text with fields


=[Address] & ',' & [City] & ' ' & [Zip]
(where [Address], [City], and [Zip] are field names and text
inside of quotation marks is text.